Here is a demo copy of the adhoc query builder for Access 2.0 It is written purely in Access code. There is no docs. I didn't feel it was necessary since it is rather straight forward. I have already received some feedback for additional add ons. The cost will be $75. This will entitle you to the entire source code plus any support you may need. I wish it could be cheaper but since the program was developed under my present employer it is they who set the price.
I am planning on adding a zoom feature to all the SQL text boxes, automating sorting feature to all the list boxes, support for multiple table joins, group by/having selection boxes, ability for the user to del\fine a limit on the number of records returned, ability to export results, and the ability to browse arbitrary results without relying on Access's default datasheet view.
If you have any questions, please feel free to contact me at billw@unomaha.edu. Thanks.
